-
Re: TextJoin
Hi @Sarah Underwood ! You might be able to mimic this by using a combination of join() and collect(). Collect() will filter out the rows based on the Branch ID, then wrapping that in the join() will …4 · -
Re: Connect and hear from past ENGAGE attendees 👋
What to say that all the others haven't? Firstly, it's a blast. There's definitely something in the air that's electric. Related to engage, definitely make sure you bring some tech to show and tell. …2 · -
Re: How would you delete a Blueprint from SCC?
@Willie Tsui the way I do it is to go into the config sheet, find the name of the "Project Type" under the "Project Settings" hierarchy, right click and delete.3 · -
Re: Excluding Zeros from an Average Formula
Hi @Stacey Gerhardt! Here's a couple options for you: AVERGAGIF() is a good option if there's only one criteria you're trying to meet, like excluding zeros. If you want to exclude more values, then u…2 · -
Re: Control Center Customize Profile Data
@Ben G thanks for the further clarification. I'm not sure if it's me, but I would have named the Approval Column, "Source" and had that displayed first, then followed up with the Target (ma…2 ·